package com.css.zfzx.fxpg.modules.surveyspot.viewobjects;

import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.handler.inter.IExcelDataModel;
import cn.afterturn.easypoi.handler.inter.IExcelModel;
import lombok.Data;

import javax.persistence.Column;
import javax.validation.constraints.NotNull;
import java.io.Serializable;

/**
 * @author leon
 * @date 2020-11-27
 */
@Data
public class FxSurveySpotVO implements Serializable, IExcelDataModel, IExcelModel {
    private Integer rowNum;
    private String errorMsg;

    @NotNull(message = "缺失")
    @Excel(name = "市县名称", width = 15)
    private String cityCountyName;

    @NotNull(message = "缺失")
    @Excel(name = "实地调查点名称", width = 15)
    private String surveySpotName;

    @NotNull(message = "缺失")
    @Excel(name = "省", width = 15)
    private String province;

    @NotNull(message = "缺失")
    @Excel(name = "市", width = 15)
    private String city;

    @NotNull(message = "缺失")
    @Excel(name = "区", width = 15)
    private String area;

    @NotNull(message = "缺失")
    @Excel(name = "年份", width = 15)
    private String year;

    @NotNull(message = "缺失")
    @Excel(name = "经度", width = 15)
    private Double longitude;

    @NotNull(message = "缺失")
    @Excel(name = "纬度", width = 15)
    private Double latitude;

    @Excel(name = "所属乡镇（村）", width = 15)
    private String township;

    @NotNull(message = "缺失")
    @Excel(name = "总户数", width = 15)
    private Double totalHouseholds;

    @NotNull(message = "缺失")
    @Excel(name = "总人口", width = 20)
    private Double totalPopulation;

    @NotNull(message = "缺失")
    @Excel(name = "实际常驻人口", width = 15)
    private Double residentPopulation;

    @Excel(name = "人均年收入（万元）", width = 20)
    private Double preYearIncome;

    @Excel(name = "外出务工人口", width = 20)
    private Double workOutsidePopulation;

    @Excel(name = "主要经济来源", width = 20)
    private String majorEconomicSource;

    @Excel(name = "人口比例（%）-少年儿童", width = 15)
    private String childrenPopulationRatio;

    @Excel(name = "人口比例（%）-中青年", width = 15)
    private String youngPopulationRatio;

    @Excel(name = "人口比例（%）-老年", width = 15)
    private String oldPopulationRatio;

    @Excel(name = "交通通达情况", width = 15)
    private String trafficAccess;

    @Excel(name = "周边地理环境", width = 15)
    private String geographicalEnvironment;

    @Excel(name = "房屋数量", width = 15)
    private Integer houseNum;

    @Excel(name = "主要建筑材料", width = 15)
    private String majorBuildingMaterial;

    @Excel(name = "房屋平均间数", width = 15)
    private Double houseAvgRoom;

    @Excel(name = "房屋平均建造成本", width = 15)
    private Double houseAvgBuildCost;

    @Excel(name = "房屋类型比例（%）-砖混结构", width = 15)
    private String houseBrickConcreteRatio;

    @Excel(name = "房屋类型比例（%）-钢混结构", width = 15)
    private String houseSteelMixedRatio;

    @Excel(name = "房屋类型比例（%）-钢结构", width = 15)
    private String houseSteelRatio;

    @Excel(name = "房屋类型比例（%）-土木结构", width = 15)
    private String houseCivilRatio;

    @Excel(name = "房屋类型比例（%）-石木结构", width = 15)
    private String houseStoneWoodRatio;

    @Excel(name = "房屋类型比例（%）-砖木结构", width = 15)
    private String houseBrickWoodRatio;

    @Excel(name = "房屋类型比例（%）-木结构", width = 20)
    private String houseWoodRatio;

    @Excel(name = "房屋类型比例（%）-其他结构", width = 15)
    private String houseOtherStructuresRatio;

    @Excel(name = "房屋建造年代比例（%）-70年代前", width = 15)
    private String houseBefore70sRatio;

    @Excel(name = "房屋建造年代比例（%）-70年代", width = 15)
    private String house70sRatio;

    @Excel(name = "房屋建造年代比例（%）-80年代", width = 15)
    private String house80sRatio;

    @Excel(name = "房屋建造年代比例（%）-90年代", width = 15)
    private String house90sRatio;

    @Excel(name = "房屋建造年代比例（%）-00年代", width = 15)
    private String house00sRatio;

    @Excel(name = "房屋建造年代比例（%）-00年代", width = 15)
    private String houseAfter10sRatio;

    @Excel(name = "周边是否有学校（是、否）", width = 15)
    private String isExistSchool;

    @Excel(name = "学生数", width = 15)
    private Integer studentNum;

    @Excel(name = "教室数", width = 15)
    private Integer classroomNum;

    @Excel(name = "周边是否有医院（是、否）", width = 15)
    private String isExistHospital;

    @Excel(name = "医生数", width = 15)
    private Integer doctorNum;

    @Excel(name = "床位数", width = 15)
    private Integer bedNum;

    @Excel(name = "周边是否有地质灾害（是、否）", width = 15)
    private String isExistGeologicalDisaster;

    @Excel(name = "类型", width = 15)
    private String type;

    @Excel(name = "规模", width = 20)
    private String scale;

    @Excel(name = "周边是否有水库（是、否）", width = 15)
    private String isExistReservoir;

    @Excel(name = "坝型", width = 20)
    private String damType;

    @Excel(name = "库容", width = 20)
    private String reservoirCapacity;

    @Excel(name = "备注说明", width = 20)
    private String remark;

}